package com.df.bpm.mapper; 

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.df.bpm.entity.RequirementCP;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface RequirementCPMapper extends BaseMapper<RequirementCP> {
    @Select("SELECT\n" +
            "\t* \n" +
            "FROM\n" +
            "\t[bpm].[requirementCP] \n" +
            "WHERE\n" +
            "\trequirementId = ${requirementId} \n" +
            "\tAND ctrlPlanId = ${ctrlPlanId} ")
    List<RequirementCP> selectO(Integer requirementId, Integer ctrlPlanId);

    @Select("SELECT\n" +
            "\t* \n" +
            "FROM\n" +
            "\t[bpm].[requirementCP] \n" +
            "WHERE\n" +
            "\trequirementId = ${requirementId} ")
    List<RequirementCP> selectListByRequirementId(Integer requirementId);
}